SELECT *, CASE WHEN `name` LIKE "blowing rock%" AND `sub_cat` IS NULL AND `cat` IS NULL AND `locality` = "blowing rock" AND `logo_file_name` IS NOT NULL THEN 10 WHEN `sub_cat` IS NULL AND `cat` IS NULL AND `locality` = "blowing rock" AND `logo_file_name` IS NOT NULL THEN 2 WHEN `sub_cat` IS NULL AND `cat` IS NULL AND `locality` = "blowing rock" AND `logo_file_name` IS NULL THEN 1 WHEN `sub_cat` IS NULL AND `cat` IS NULL AND `locality` IS NULL AND `logo_file_name` IS NULL THEN 0 END as `rank` FROM `wp_slides` WHERE st = "NC" AND (locality IN ("blowing rock") OR locality IS NULL) AND (cat IS NULL) AND name NOT IN ("home-top", "home-bot") AND (slide_file_name IS NOT NULL AND slide_file_name != "") AND (slide_location IS NULL OR slide_location = "") AND name NOT IN ("agent") AND active = 1 ORDER BY `rank` DESC LIMIT 12
[0] matching rows / [0.00 msec]
Blog ID 10
Blah
SELECT *, "0" as `rank` FROM `wp_slides` WHERE st = "NC" AND (cat IS NULL) AND (slide_file_name IS NOT NULL AND slide_file_name != "") AND (slide_location IS NULL OR slide_location = "") AND active = 1 ORDER BY `rank` DESC LIMIT 12
[0] matching rows / [0.00 msec]
Blog ID 10
Blah
Get email when new and updated listings match this saved search.
Get email when newly sold listings match this saved search.
Save Search
Delete Shape
Click on these drawing tools to draw shapes to contain listings. You can save these shapes as a Saved Search.
$3,400,000194 Laurel Park RdBlowing Rock NC 28605View Listing
$2,950,000116 Globe RdBlowing Rock NC 28605View Listing
$2,399,000216 Dogwood LnBlowing Rock NC 28605View Listing
$2,392,000385 Saddle Way DrBlowing Rock NC 28605View Listing
$1,699,000256 Green Hill RdBlowing Rock NC 28605View Listing
$1,645,000371 Green Hill WoodsBlowing Rock NC 28605View Listing
$1,490,000119 Hemlock LnBlowing Rock NC 28605View Listing
$1,425,000201 and 202 Ovens LnBlowing Rock NC 28605View Listing
$1,425,000145 Brave HawkBlowing Rock NC 28605View Listing
$1,325,000128 Starry Night TrlBlowing Rock NC 28605View Listing
$1,300,000127 Bitter Root DrBlowing Rock NC 28605View Listing
$1,240,000300 Misty Ridge LnBlowing Rock NC 28605View Listing
$1,150,000394 Misty Ridge LnBlowing Rock NC 28605View Listing
$1,150,000113 Bella DrBlowing Rock NC 28605View Listing
$1,100,000333 Country Club DrBlowing Rock NC 28605View Listing
$1,100,0008015 Cloud Forest LnBlowing Rock NC 28605View Listing
$1,100,000368 Green Hill WoodsBlowing Rock NC 28605View Listing
$995,000Country Club LnBlowing Rock NC 28605View Listing
$995,000146 Pack Hill RdBlowing Rock NC 28605View Listing
$975,000655 Black Locust CirBlowing Rock NC 28605View Listing
$949,900143 Choctaw Camp LnBlowing Rock NC 28605View Listing
$899,900486 Ransom St Unit 1Blowing Rock NC 28605View Listing
$899,000214 Maple StBlowing Rock NC 28605View Listing
$844,000192 Morning StarBlowing Rock NC 28605View Listing
The data relating to real estate for sale on this site comes from ListHub. All properties are subject to prior sale, changes, or withdrawal. This site was last updated May-08-2024 10:27:47 pm.
SELECT *, "0" as `rank` FROM `wp_slides` WHERE st = "NC" AND (cat = "lenders" OR cat IS NULL) AND (slide_file_name IS NOT NULL AND slide_file_name != "") AND (slide_location IS NULL OR slide_location = "") AND active = 1 ORDER BY `rank` DESC LIMIT 12
[0] matching rows / [0.00 msec]
Blog ID 10
Blah
Ranch
Single Family
